SAS ® Scalable Performance Data Server ® : Star Schema Support

Stars and Models: How to Build and Maintain Star Schemas Using SAS Data Integration Server in SAS®9

ABSTRACT Star schemas are used in data warehouses as the primary storage mechanism for dimensional data that is to be queried efficiently. Star schemas are the final result of the extract, transform, and load (ETL) processes that are used in building the data warehouse. Efficiently building the star schema is important, especially as the data volumes that are required to be stored in the data w...

SUGI 27: Up and Out: Where We're Going with Scalability in SAS(r) Version 9

This paper gives an overview of the ways that SAS is addressing performance through scalability in SAS Version 9. Scalability features have been implemented in many areas of SAS Version 9 to allow your applications to scale up and scale out. These include: • Multi-Process (MP) CONNECT, • the Scalable Performance Data Engine (SPDE engine), • certain SAS/ACCESS engines, • several scalable SAS pro...

SAS Scalable Performance Data Server 5.2: Administrator'sGuide

SAS Scalable Performance Data Server 5.2: User's Guide

Managing large Data with SAS SPD Server

This paper provides the concepts behind demonstrations of how you can enhance query performance when you use the SAS SPD Server to manage large data tables. This paper does not cover the main concepts for Dynamic Clusters or Parallel Join. See white papers TW9593 and TW9594 for thorough discussions of the Dynamic Cluster and Parallel Join features. This paper focuses on managing data within sta...